Calling a Stored Procedure

You call stored procedures using a Command object. When you issue a command on a stored procedure, you must set the CommandType of the Command object to StoredProcedure.

The following code example shows how to execute a stored procedure on a Sybase database and read the results using a DataReader. The example uses the emp table (see "Sample Tables for Sybase"). The Sybase database in this example does not require the Database connection string option.

Create the following stored procedure:

CREATE PROCEDURE GetEmpSalary 
    (@empno int, 
     @sal char(7) output) 
AS 
SELECT @sal = sal FROM emp WHERE empno = @empno 

The following code example executes the GetEmpSalary stored procedure:

// Open connection to SequeLink Server on Sybase database 
SybaseConnection  Conn; 
Conn = new SequeLinkConnection("host=bowhead;port=19996;User ID=test01; 
                               Password=test01"); 
Conn.Open(); 
// Make a command object for the stored procedure 
// You must set the CommandType of the Command object  
// to StoredProcedure  
SequeLinkCommand   DBCmd = new SequeLinkCommand("GetEmpSalary",Conn); 
DBCmd.CommandType = CommandType.StoredProcedure; 
SequeLinkDataReader  myDataReader; 
try 
{ 
    myDataReader = myCommand.ExecuteReader() 
    myDataReader.Close(); 
} 
catch (Exception ex)  
{ 
    // Display any exceptions in a messagebox 
    MessageBox.Show (ex.Message); 
} 
//  Close the connection 
Conn.Close();